package cn.gson.fengboot.model.dao;

import cn.gson.fengboot.model.pojos.Doffer;
import cn.gson.fengboot.model.pojos.Dscheme;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

public interface DofferDao extends CrudRepository<Doffer,Integer> {

    @Query(value = "select d.* from  doffer d  where d.offer_theme=?1 and d.offer_people=?2", nativeQuery = true)
    Doffer findByOfferTheme(String offerTheme, String getbuspeople);
}
